﻿<%@ Page Language="C#" MasterPageFile="~/PersonNav.master" AutoEventWireup="true" CodeFile="MyApplyInfo.aspx.cs" Inherits="MyApplyInfo" Title="无锡校园人才网-我的申请记录" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="PersonRight" runat="Server">
    <div class="rightHeader1">
        <div class="rightHLeft"><span class="rightHeaderTitle">当前位置</span></div>
        <div class="rightHMiddle2">
            <span>
                <a href="Default.aspx" class="moreRight" style="float: left;">首页</a> <span class="jian">></span>
                <a href="MyApplyInfo.aspx" class="moreRight" style="float: left;">我的申请</a>
            </span>
        </div>
        <div class="rightHRight"></div>
    </div>
    <div style="margin-top: 10px;">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            CellPadding="4" DataKeyNames="jaid" DataSourceID="SqlDataSource1"
            ForeColor="#333333" GridLines="None" Width="768px" AllowPaging="True"
            AllowSorting="True" OnRowDeleting="GridView1_RowDeleting" OnPageIndexChanging="GridView1_PageIndexChanging">
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#EFF3FB" />
            <Columns>
                <asp:TemplateField HeaderText="公司名称" SortExpression="cpname">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("cpname") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink1" runat="server"
                            NavigateUrl='<%# "Cominfo.aspx?qy="+Eval("cpid") %>'
                            Text='<%# Eval("cpname") %>'></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="职位名称" SortExpression="cwname">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("cwname") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:HyperLink ID="HyperLink2" runat="server"
                            NavigateUrl='<%# "zwinfo.aspx?zw="+Eval("cwid") %>'
                            Text='<%# Eval("cwname") %>'></asp:HyperLink>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="trname" HeaderText="行业类别" SortExpression="trname" />
                <asp:BoundField DataField="jcname" HeaderText="招聘类别" SortExpression="jcname" />
                <asp:BoundField DataField="jatime" DataFormatString="{0:d}" HeaderText="申请时间"
                    SortExpression="jatime" />
                <asp:CommandField ShowDeleteButton="True" />
            </Columns>
            <PagerStyle BackColor="#159fde" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#159fde" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:DB_CCXYRCConnectionString %>"
            SelectCommand="SELECT tb_jobapply.jaid, tb_jobapply.pid, tb_jobapply.cwid, tb_jobapply.jatime, tb_jobapply.islook, tb_jobclass.jcname, tb_trade.trname, tb_company.cpname, tb_company.cpid, tb_comwant.cwname FROM tb_jobapply INNER JOIN tb_comwant ON tb_jobapply.cwid = tb_comwant.cwid INNER JOIN tb_company ON tb_comwant.cpid = tb_company.cpid INNER JOIN tb_trade ON tb_comwant.trid = tb_trade.trid INNER JOIN tb_jobclass ON tb_comwant.jcid = tb_jobclass.jcid WHERE (tb_jobapply.pid = @pid)"
            ConflictDetection="CompareAllValues"
            DeleteCommand="DELETE FROM [tb_jobapply] WHERE [jaid] = @original_jaid"
            InsertCommand="INSERT INTO [tb_jobapply] ([pid], [cwid], [jatime], [islook]) VALUES (@pid, @cwid, @jatime, @islook)"
            OldValuesParameterFormatString="original_{0}"
            UpdateCommand="UPDATE [tb_jobapply] SET [pid] = @pid, [cwid] = @cwid, [jatime] = @jatime, [islook] = @islook WHERE [jaid] = @original_jaid AND [pid] = @original_pid AND [cwid] = @original_cwid AND [jatime] = @original_jatime AND [islook] = @original_islook">
            <SelectParameters>
                <asp:SessionParameter Name="pid" SessionField="person" Type="String" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="original_jaid" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="pid" Type="String" />
                <asp:Parameter Name="cwid" Type="Int32" />
                <asp:Parameter Name="jatime" Type="DateTime" />
                <asp:Parameter Name="islook" Type="Boolean" />
                <asp:Parameter Name="original_jaid" Type="Int32" />
                <asp:Parameter Name="original_pid" Type="String" />
                <asp:Parameter Name="original_cwid" Type="Int32" />
                <asp:Parameter Name="original_jatime" Type="DateTime" />
                <asp:Parameter Name="original_islook" Type="Boolean" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="pid" Type="String" />
                <asp:Parameter Name="cwid" Type="Int32" />
                <asp:Parameter Name="jatime" Type="DateTime" />
                <asp:Parameter Name="islook" Type="Boolean" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:Label ID="Label1" runat="server"></asp:Label>
    </div>
</asp:Content>

